/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */

package com.googlecode.jsimplemarket.repository;

import com.googlecode.jsimplemarket.model.Inchiriere;

//import java.math.BigDecimal;
import java.util.Date;
import java.util.List;
import org.springframework.data.repository.CrudRepository;

/**
 *
 * @author Alexandru.Codescu
 */
public interface InchiriereRepository extends CrudRepository<Inchiriere, Long> {
    List<Object[]> queryIncasariByData(Date data1, Date data2);
    List<Object[]> queryIncasariByDataPlata(Date data);
    List<Object[]> queryIncasariByDataPlataDetailed(Date data);
    List<Object[]> queryTarabeByData(Date data1, Date data2);
    List<Object[]> queryTarabeByDataAA(Date data1, Date data2);
    List<Object[]> queryInchirieriByTarabaByDay(Date data1, Date data2, Long id);
//    List<Object[]> queryTarabeByDataPlata(Date data1);
    List<Object[]> queryFirmaByTaraba(Long id, Date data1, Date data2);
    List<Object[]> querySumIncasariByData(Date data1, Date data2);
    List<Object[]> querySumIncasariByDataTZ(Date data1, Date data2);//incasari zilnice din taxe zilnice
    List<Object[]> querySumIncasariByDataAA(Date data1, Date data2);//incasari zilnice din taxe anticipate
    List<Object[]> querySumIncasariByDataPlata(Date data);
//    List<Object[]> queryAllByDay(Date data1, Date data2, Long id);
}
